| FHIR | Database mappings - DB table (DB field) | Hard Coded Value / Calculation/ URL Constuction | 
|---|
| resourceType |  | "Bundle" | 
| id |  | uuid() | 
| meta.lastUpdated | formularies (update_date) |  | 
| type |  | "searchset" | 
| link.relation |  | "self" | 
| link.url |  | populate current URL | 
The following are the elements inside an entry array:
| FHIR | Database mappings - DB table (DB field) | Hard Coded Value / Calculation/ URL Constuction | 
|---|
| entry.fullUrl | formularies (formulary_id) | [fhir.host] ++ [fhir.requestUri] ++ formulery_id | 
| entry.search.mode |  | "match" | 
The following are the elements inside a resource:
| FHIR | Database mappings - DB table (DB field) | Hard Coded Value / Calculation/ URL Constuction | 
|---|
| resource.resourceType |  | "MedicationKnowledge" | 
| resource.id |  | formularies (formulary_id) | 
| resource.meta.profile |  | [formulary.url] ++ "usdf-FormularyDrug" | 
| resource.text.status |  | "generated" | 
The following are the elements inside resource.extension:
| FHIR | Database mappings - DB table (DB field) | Hard Coded Value / Calculation/ URL Constuction | 
|---|
| resource.extension[0].url |  | [formulary.url] ++ "usdf-DrugTierID-extension" | 
| resource.extension[0]...system |  | [formulary.url] ++ "usdf-DrugTierCS" | 
| resource.extension[0]...code | formularies (fdrug_tier_id_code) |  | 
| resource.extension[0]...display | formularies (fdrug_tier_id_name) |  | 
| resource.extension[1].url |  | [formulary.url] ++ "usdf-PriorAuthorization-extension" | 
| resource.extension[1]..valueBoolean | formularies (fprior_authorization) |  | 
| resource.extension[2]..url |  | [formulary.url] ++ "usdf-StepTherapyLimit-extension" | 
| resource.extension[2]..valueBoolean | formularies (fstep_therapy_limit) |  | 
| resource.extension[3]..url |  | [formulary.url] ++ "usdf-QuantityLimit-extension" | 
| resource.extension[3]..valueBoolean | formularies (fitem.quantity_limit) |  | 
| resource.extension[4]..url |  | [formulary.url] ++ "usdf-PlanID-extension" | 
| resource.extension[4]..valueString | formularies (fplan_id) |  | 
| resource.code...system |  | [formulary.url] ++ "rxnorm" | 
| resource.code...code | formularies (fdrug_rx_code) |  | 
| resource.code...display | formularies (fdrug_name) |  |